Pandas Profiling Report

Dataset statistics

Number of variables	24
Number of observations	41703
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	8.0 MiB
Average record size in memory	200.0 B

Variable types

Categorical	12
Numeric	11
DateTime	1

Alerts

`num_units` has constant value ""	Constant
`project_name` has a high cardinality: 1948 distinct values	High cardinality
`address` has a high cardinality: 41672 distinct values	High cardinality
`nett_price` has a high cardinality: 139 distinct values	High cardinality
`tenure` has a high cardinality: 428 distinct values	High cardinality
`area_sqm` is highly overall correlated with `total_price`	High correlation
`total_price` is highly overall correlated with `area_sqm` and 1 other fields	High correlation
`price_psm` is highly overall correlated with `price_psf` and 4 other fields	High correlation
`price_psf` is highly overall correlated with `price_psm` and 4 other fields	High correlation
`completion_date` is highly overall correlated with `sale_type`	High correlation
`postal_district` is highly overall correlated with `price_psm` and 7 other fields	High correlation
`postal_sector` is highly overall correlated with `price_psm` and 7 other fields	High correlation
`postal_code` is highly overall correlated with `price_psm` and 7 other fields	High correlation
`lat` is highly overall correlated with `total_price` and 7 other fields	High correlation
`lon` is highly overall correlated with `planning_region` and 1 other fields	High correlation
`property_type` is highly overall correlated with `planning_area`	High correlation
`sale_type` is highly overall correlated with `completion_date`	High correlation
`planning_region` is highly overall correlated with `postal_district` and 5 other fields	High correlation
`planning_area` is highly overall correlated with `postal_district` and 7 other fields	High correlation
`is_leasehold` is highly overall correlated with `postal_district` and 3 other fields	High correlation
`area_type` is highly imbalanced (> 99.9%)	Imbalance
`nett_price` is highly imbalanced (99.2%)	Imbalance
`address` is uniformly distributed	Uniform

Reproduction

Analysis started	2023-04-19 12:19:27.611798
Analysis finished	2023-04-19 12:19:35.829458
Duration	8.22 seconds
Software version	ydata-profiling v0.0.dev0
Download configuration	config.json

project_name
Categorical

Distinct	1948
Distinct (%)	4.7%
Missing	0
Missing (%)	0.0%
Memory size	651.6 KiB

RIVERFRONT RESIDENCES	936
RIVERCOVE RESIDENCES	620
THE TAPESTRY	613
STIRLING RESIDENCES	598
PARK COLONIAL	579
Other values (1943)	38357

Length

Max length	47
Median length	28
Mean length	14.165288
Min length	2

Characters and Unicode

Total characters	590735
Distinct characters	44
Distinct categories	5 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	274 ?
Unique (%)	0.7%

Sample

1st row	THE BAYSHORE
2nd row	KINGSFORD WATERBAY
3rd row	THE JOVELL
4th row	V ON SHENTON
5th row	THE BEACON

Common Values

Value	Count	Frequency (%)
RIVERFRONT RESIDENCES	936	2.2%
RIVERCOVE RESIDENCES	620	1.5%
THE TAPESTRY	613	1.5%
STIRLING RESIDENCES	598	1.4%
PARK COLONIAL	579	1.4%
PARC BOTANNIA	535	1.3%
HUNDRED PALMS RESIDENCES	531	1.3%
KINGSFORD WATERBAY	513	1.2%
PARC ESTA	483	1.2%
AFFINITY AT SERANGOON	468	1.1%
Other values (1938)	35827	85.9%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
residences	7815	8.7%
the	7785	8.7%
park	2986	3.3%
parc	2264	2.5%
at	1973	2.2%
condominium	1062	1.2%
	1025	1.1%
residence	993	1.1%
riverfront	936	1.0%
suites	795	0.9%
Other values (1600)	62023	69.2%

Most occurring characters

Value	Count	Frequency (%)
E	81353	13.8%
R	49120	8.3%
	47954	8.1%
A	45681	7.7%
S	45320	7.7%
I	42357	7.2%
N	40704	6.9%
T	35250	6.0%
O	26287	4.4%
C	22272	3.8%
Other values (34)	154437	26.1%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	537960	91.1%
Space Separator	47954	8.1%
Decimal Number	2799	0.5%
Other Punctuation	1908	0.3%
Dash Punctuation	114	< 0.1%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
E	81353	15.1%
R	49120	9.1%
A	45681	8.5%
S	45320	8.4%
I	42357	7.9%
N	40704	7.6%
T	35250	6.6%
O	26287	4.9%
C	22272	4.1%
L	20717	3.9%
Other values (16)	128899	24.0%

Decimal Number

Value	Count	Frequency (%)
8	747	26.7%
1	402	14.4%
3	393	14.0%
2	347	12.4%
6	239	8.5%
5	236	8.4%
0	181	6.5%
4	146	5.2%
7	55	2.0%
9	53	1.9%

Other Punctuation

Value	Count	Frequency (%)
@	1292	67.7%
'	449	23.5%
.	132	6.9%
&	23	1.2%
#	8	0.4%
/	4	0.2%

Space Separator

Value	Count	Frequency (%)
	47954	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	114	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	537960	91.1%
Common	52775	8.9%

Most frequent character per script

Latin

Value	Count	Frequency (%)
E	81353	15.1%
R	49120	9.1%
A	45681	8.5%
S	45320	8.4%
I	42357	7.9%
N	40704	7.6%
T	35250	6.6%
O	26287	4.9%
C	22272	4.1%
L	20717	3.9%
Other values (16)	128899	24.0%

Common

Value	Count	Frequency (%)
	47954	90.9%
@	1292	2.4%
8	747	1.4%
'	449	0.9%
1	402	0.8%
3	393	0.7%
2	347	0.7%
6	239	0.5%
5	236	0.4%
0	181	0.3%
Other values (8)	535	1.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	590735	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
E	81353	13.8%
R	49120	8.3%
	47954	8.1%
A	45681	7.7%
S	45320	7.7%
I	42357	7.2%
N	40704	6.9%
T	35250	6.0%
O	26287	4.4%
C	22272	3.8%
Other values (34)	154437	26.1%

address
Categorical

HIGH CARDINALITY UNIFORM

Distinct	41672
Distinct (%)	99.9%
Missing	0
Missing (%)	0.0%
Memory size	651.6 KiB

489 Dunman Road #03-03	2
5 Jervois Close #07-10	2
70 Upper Serangoon View #07-33	2
376 Thomson Road #25-05	2
103 Prince Charles Crescent #09-07	2
Other values (41667)	41693

Length

Max length	42
Median length	34
Mean length	27.228761
Min length	13

Characters and Unicode

Total characters	1135521
Distinct characters	66
Distinct categories	6 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	41641 ?
Unique (%)	99.9%

Sample

1st row	22 Bayshore Road #03-02
2nd row	66 Upper Serangoon View #16-12
3rd row	13 Flora Drive #02-11
4th row	5A Shenton Way #44-12
5th row	130 Cantonment Road #10-04

Common Values

Value	Count	Frequency (%)
489 Dunman Road #03-03	2	< 0.1%
5 Jervois Close #07-10	2	< 0.1%
70 Upper Serangoon View #07-33	2	< 0.1%
376 Thomson Road #25-05	2	< 0.1%
103 Prince Charles Crescent #09-07	2	< 0.1%
10 Boon Lay Drive #03-30	2	< 0.1%
10 Martin Place #11-13	2	< 0.1%
336 River Valley Road #07-01	2	< 0.1%
4 Kovan Rise #08-09	2	< 0.1%
36 Dakota Crescent #14-05	2	< 0.1%
Other values (41662)	41683	> 99.9%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
road	12726	6.6%
avenue	5670	2.9%
street	4292	2.2%
1	3184	1.6%
drive	2511	1.3%
3	1811	0.9%
7	1804	0.9%
serangoon	1771	0.9%
lane	1760	0.9%
coast	1718	0.9%
Other values (4238)	156067	80.7%

Most occurring characters

Value	Count	Frequency (%)
	234890	20.7%
e	63924	5.6%
a	57678	5.1%
0	56184	4.9%
1	53099	4.7%
o	45545	4.0%
n	42066	3.7%
-	41610	3.7%
#	41576	3.7%
2	32326	2.8%
Other values (56)	466623	41.1%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	452138	39.8%
Decimal Number	261712	23.0%
Space Separator	234890	20.7%
Uppercase Letter	103208	9.1%
Other Punctuation	41963	3.7%
Dash Punctuation	41610	3.7%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	63924	14.1%
a	57678	12.8%
o	45545	10.1%
n	42066	9.3%
r	32083	7.1%
i	28074	6.2%
t	25068	5.5%
d	19310	4.3%
l	19288	4.3%
s	19018	4.2%
Other values (16)	100084	22.1%

Uppercase Letter

Value	Count	Frequency (%)
R	15905	15.4%
S	12154	11.8%
C	9916	9.6%
A	8592	8.3%
L	6388	6.2%
P	5613	5.4%
B	5096	4.9%
T	4868	4.7%
W	4448	4.3%
K	3727	3.6%
Other values (15)	26501	25.7%

Decimal Number

Value	Count	Frequency (%)
0	56184	21.5%
1	53099	20.3%
2	32326	12.4%
3	26023	9.9%
5	19019	7.3%
6	17300	6.6%
4	17088	6.5%
8	14946	5.7%
7	14099	5.4%
9	11628	4.4%

Other Punctuation

Value	Count	Frequency (%)
#	41576	99.1%
.	242	0.6%
'	145	0.3%

Space Separator

Value	Count	Frequency (%)
	234890	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	41610	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	580175	51.1%
Latin	555346	48.9%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	63924	11.5%
a	57678	10.4%
o	45545	8.2%
n	42066	7.6%
r	32083	5.8%
i	28074	5.1%
t	25068	4.5%
d	19310	3.5%
l	19288	3.5%
s	19018	3.4%
Other values (41)	203292	36.6%

Common

Value	Count	Frequency (%)
	234890	40.5%
0	56184	9.7%
1	53099	9.2%
-	41610	7.2%
#	41576	7.2%
2	32326	5.6%
3	26023	4.5%
5	19019	3.3%
6	17300	3.0%
4	17088	2.9%
Other values (5)	41060	7.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1135521	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	234890	20.7%
e	63924	5.6%
a	57678	5.1%
0	56184	4.9%
1	53099	4.7%
o	45545	4.0%
n	42066	3.7%
-	41610	3.7%
#	41576	3.7%
2	32326	2.8%
Other values (56)	466623	41.1%

num_units
Categorical

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	651.6 KiB

1	41703

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	41703
Distinct characters	1
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	1
2nd row	1
3rd row	1
4th row	1
5th row	1

Common Values

Value	Count	Frequency (%)
1	41703	100.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
1	41703	100.0%

Most occurring characters

Value	Count	Frequency (%)
1	41703	100.0%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	41703	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
1	41703	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	41703	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
1	41703	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	41703	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
1	41703	100.0%

area_sqm
Real number (ℝ)

Distinct	432
Distinct (%)	1.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	99.724193

Minimum	24
Maximum	898
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	651.6 KiB

Quantile statistics

Minimum	24
5-th percentile	43
Q1	67
median	93
Q3	117
95-th percentile	181
Maximum	898
Range	874
Interquartile range (IQR)	50

Descriptive statistics

Standard deviation	50.723676
Coefficient of variation (CV)	0.50863962
Kurtosis	21.104631
Mean	99.724193
Median Absolute Deviation (MAD)	25
Skewness	3.1329406
Sum	4158798
Variance	2572.8913
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
43	709	1.7%
103	680	1.6%
89	668	1.6%
91	622	1.5%
85	592	1.4%
84	589	1.4%
99	579	1.4%
98	554	1.3%
65	548	1.3%
57	543	1.3%
Other values (422)	35619	85.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
24	1	< 0.1%
30	3	< 0.1%
31	12	< 0.1%
32	23	0.1%
33	33	0.1%
34	68	0.2%
35	39	0.1%
36	54	0.1%
37	96	0.2%
38	78	0.2%

Value	Count	Frequency (%)
898	1	< 0.1%
864	1	< 0.1%
742	1	< 0.1%
728	1	< 0.1%
717	1	< 0.1%
697	1	< 0.1%
677	2	< 0.1%
657	1	< 0.1%
656	1	< 0.1%
655	1	< 0.1%

area_type
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	651.6 KiB

Strata	41702
Land	1

Length

Max length	6
Median length	6
Mean length	5.999952
Min length	4

Characters and Unicode

Total characters	250216
Distinct characters	7
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1 ?
Unique (%)	< 0.1%

Sample

1st row	Strata
2nd row	Strata
3rd row	Strata
4th row	Strata
5th row	Strata

Common Values

Value	Count	Frequency (%)
Strata	41702	> 99.9%
Land	1	< 0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
strata	41702	> 99.9%
land	1	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
a	83405	33.3%
t	83404	33.3%
S	41702	16.7%
r	41702	16.7%
L	1	< 0.1%
n	1	< 0.1%
d	1	< 0.1%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	208513	83.3%
Uppercase Letter	41703	16.7%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
a	83405	40.0%
t	83404	40.0%
r	41702	20.0%
n	1	< 0.1%
d	1	< 0.1%

Uppercase Letter

Value	Count	Frequency (%)
S	41702	> 99.9%
L	1	< 0.1%

Most occurring scripts

Value	Count	Frequency (%)
Latin	250216	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
a	83405	33.3%
t	83404	33.3%
S	41702	16.7%
r	41702	16.7%
L	1	< 0.1%
n	1	< 0.1%
d	1	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	250216	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
a	83405	33.3%
t	83404	33.3%
S	41702	16.7%
r	41702	16.7%
L	1	< 0.1%
n	1	< 0.1%
d	1	< 0.1%

total_price
Real number (ℝ)

Distinct	9151
Distinct (%)	21.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1467677.4

Minimum	358000
Maximum	36280000
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	651.6 KiB

Quantile statistics

Minimum	358000
5-th percentile	668530
Q1	903000
median	1190000
Q3	1626719.5
95-th percentile	3067814
Maximum	36280000
Range	35922000
Interquartile range (IQR)	723719.5

Descriptive statistics

Standard deviation	1139893.6
Coefficient of variation (CV)	0.77666493
Kurtosis	82.524626
Mean	1467677.4
Median Absolute Deviation (MAD)	330000
Skewness	6.4045092
Sum	6.1206552 × 10¹⁰
Variance	1.2993574 × 10¹²
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1200000	306	0.7%
1100000	301	0.7%
1300000	262	0.6%
1050000	258	0.6%
1150000	252	0.6%
1500000	226	0.5%
1400000	218	0.5%
1350000	211	0.5%
1180000	205	0.5%
1250000	205	0.5%
Other values (9141)	39259	94.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
358000	1	< 0.1%
362000	1	< 0.1%
369000	1	< 0.1%
371000	1	< 0.1%
373000	1	< 0.1%
376000	2	< 0.1%
380000	1	< 0.1%
383000	1	< 0.1%
388000	1	< 0.1%
392000	2	< 0.1%

Value	Count	Frequency (%)
36280000	1	< 0.1%
28000000	1	< 0.1%
26000000	1	< 0.1%
25575000	1	< 0.1%
24500000	1	< 0.1%
24000000	1	< 0.1%
21861000	1	< 0.1%
20800000	1	< 0.1%
19600000	1	< 0.1%
18270240	1	< 0.1%

nett_price
Categorical

HIGH CARDINALITY IMBALANCE

Distinct	139
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Memory size	651.6 KiB

-	41558
895000	2
889000	2
853000	2
802700	2
Other values (134)	137

Length

Max length	7
Median length	1
Mean length	1.0191113
Min length	1

Characters and Unicode

Total characters	42500
Distinct characters	11
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	131 ?
Unique (%)	0.3%

Sample

1st row	-
2nd row	-
3rd row	-
4th row	2847680
5th row	-

Common Values

Value	Count	Frequency (%)
-	41558	99.7%
895000	2	< 0.1%
889000	2	< 0.1%
853000	2	< 0.1%
802700	2	< 0.1%
1296000	2	< 0.1%
887000	2	< 0.1%
868420	2	< 0.1%
2927161	1	< 0.1%
995712	1	< 0.1%
Other values (129)	129	0.3%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
	41558	99.7%
889000	2	< 0.1%
853000	2	< 0.1%
802700	2	< 0.1%
1296000	2	< 0.1%
887000	2	< 0.1%
868420	2	< 0.1%
895000	2	< 0.1%
825700	1	< 0.1%
856000	1	< 0.1%
Other values (129)	129	0.3%

Most occurring characters

Value	Count	Frequency (%)
-	41558	97.8%
0	329	0.8%
1	118	0.3%
8	88	0.2%
4	69	0.2%
9	67	0.2%
7	63	0.1%
2	58	0.1%
3	53	0.1%
5	51	0.1%

Most occurring categories

Value	Count	Frequency (%)
Dash Punctuation	41558	97.8%
Decimal Number	942	2.2%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	329	34.9%
1	118	12.5%
8	88	9.3%
4	69	7.3%
9	67	7.1%
7	63	6.7%
2	58	6.2%
3	53	5.6%
5	51	5.4%
6	46	4.9%

Dash Punctuation

Value	Count	Frequency (%)
-	41558	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	42500	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
-	41558	97.8%
0	329	0.8%
1	118	0.3%
8	88	0.2%
4	69	0.2%
9	67	0.2%
7	63	0.1%
2	58	0.1%
3	53	0.1%
5	51	0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	42500	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
-	41558	97.8%
0	329	0.8%
1	118	0.3%
8	88	0.2%
4	69	0.2%
9	67	0.2%
7	63	0.1%
2	58	0.1%
3	53	0.1%
5	51	0.1%

price_psm
Real number (ℝ)

Distinct	14851
Distinct (%)	35.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	14937.68

Minimum	4762
Maximum	53030
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	651.6 KiB

Quantile statistics

Minimum	4762
5-th percentile	8116
Q1	10848.5
median	14338
Q3	17813.5
95-th percentile	24754.4
Maximum	53030
Range	48268
Interquartile range (IQR)	6965

Descriptive statistics

Standard deviation	5451.919
Coefficient of variation (CV)	0.36497764
Kurtosis	2.8492157
Mean	14937.68
Median Absolute Deviation (MAD)	3484
Skewness	1.2749083
Sum	6.2294605 × 10⁸
Variance	29723421
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
10000	130	0.3%
15000	84	0.2%
16667	73	0.2%
12500	73	0.2%
20000	67	0.2%
14000	56	0.1%
13333	56	0.1%
14286	56	0.1%
16000	48	0.1%
18000	48	0.1%
Other values (14841)	41012	98.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
4762	1	< 0.1%
4875	1	< 0.1%
5251	1	< 0.1%
5275	1	< 0.1%
5325	1	< 0.1%
5353	1	< 0.1%
5357	1	< 0.1%
5358	1	< 0.1%
5392	1	< 0.1%
5414	1	< 0.1%

Value	Count	Frequency (%)
53030	1	< 0.1%
49835	1	< 0.1%
49080	1	< 0.1%
46667	1	< 0.1%
46281	1	< 0.1%
44984	1	< 0.1%
44940	1	< 0.1%
44892	1	< 0.1%
44113	1	< 0.1%
43919	1	< 0.1%

price_psf
Real number (ℝ)

Distinct	2748
Distinct (%)	6.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1387.7441

Minimum	442
Maximum	4927
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	651.6 KiB

Quantile statistics

Minimum	442
5-th percentile	754
Q1	1008
median	1332
Q3	1655
95-th percentile	2299.9
Maximum	4927
Range	4485
Interquartile range (IQR)	647

Descriptive statistics

Standard deviation	506.49361
Coefficient of variation (CV)	0.36497622
Kurtosis	2.8493611
Mean	1387.7441
Median Absolute Deviation (MAD)	324
Skewness	1.274937
Sum	57873093
Variance	256535.77
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
929	132	0.3%
1548	96	0.2%
1394	89	0.2%
1327	79	0.2%
1161	76	0.2%
1858	70	0.2%
1301	69	0.2%
1032	66	0.2%
1239	65	0.2%
1340	64	0.2%
Other values (2738)	40897	98.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
442	1	< 0.1%
453	1	< 0.1%
488	1	< 0.1%
490	1	< 0.1%
495	1	< 0.1%
497	1	< 0.1%
498	2	< 0.1%
501	1	< 0.1%
503	1	< 0.1%
506	2	< 0.1%

Value	Count	Frequency (%)
4927	1	< 0.1%
4630	1	< 0.1%
4560	1	< 0.1%
4335	1	< 0.1%
4300	1	< 0.1%
4179	1	< 0.1%
4175	1	< 0.1%
4171	1	< 0.1%
4098	1	< 0.1%
4080	1	< 0.1%

sale_date
Date

Distinct	698
Distinct (%)	1.7%
Missing	0
Missing (%)	0.0%
Memory size	651.6 KiB

Minimum	2017-05-01 00:00:00
Maximum	2019-03-31 00:00:00

Histogram

Histogram with fixed size bins (bins=50)

property_type
Categorical

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	651.6 KiB

Condominium	22201
Apartment	14940
Executive Condominium	4562

Length

Max length	21
Median length	11
Mean length	11.377431
Min length	9

Characters and Unicode

Total characters	474473
Distinct characters	18
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Condominium
2nd row	Apartment
3rd row	Condominium
4th row	Apartment
5th row	Apartment

Common Values

Value	Count	Frequency (%)
Condominium	22201	53.2%
Apartment	14940	35.8%
Executive Condominium	4562	10.9%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
condominium	26763	57.8%
apartment	14940	32.3%
executive	4562	9.9%

Most occurring characters

Value	Count	Frequency (%)
n	68466	14.4%
m	68466	14.4%
i	58088	12.2%
o	53526	11.3%
t	34442	7.3%
u	31325	6.6%
C	26763	5.6%
d	26763	5.6%
e	24064	5.1%
r	14940	3.1%
Other values (8)	67630	14.3%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	423646	89.3%
Uppercase Letter	46265	9.8%
Space Separator	4562	1.0%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
n	68466	16.2%
m	68466	16.2%
i	58088	13.7%
o	53526	12.6%
t	34442	8.1%
u	31325	7.4%
d	26763	6.3%
e	24064	5.7%
r	14940	3.5%
a	14940	3.5%
Other values (4)	28626	6.8%

Uppercase Letter

Value	Count	Frequency (%)
C	26763	57.8%
A	14940	32.3%
E	4562	9.9%

Space Separator

Value	Count	Frequency (%)
	4562	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	469911	99.0%
Common	4562	1.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
n	68466	14.6%
m	68466	14.6%
i	58088	12.4%
o	53526	11.4%
t	34442	7.3%
u	31325	6.7%
C	26763	5.7%
d	26763	5.7%
e	24064	5.1%
r	14940	3.2%
Other values (7)	63068	13.4%

Common

Value	Count	Frequency (%)
	4562	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	474473	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
n	68466	14.4%
m	68466	14.4%
i	58088	12.2%
o	53526	11.3%
t	34442	7.3%
u	31325	6.6%
C	26763	5.6%
d	26763	5.6%
e	24064	5.1%
r	14940	3.1%
Other values (8)	67630	14.3%

tenure
Categorical

Distinct	428
Distinct (%)	1.0%
Missing	0
Missing (%)	0.0%
Memory size	651.6 KiB

Freehold	11073
99 Yrs From 31/05/2018	936
99 Yrs From 05/12/2016	620
99 Yrs From 31/07/2017	613
99 Yrs From 25/08/2014	599
Other values (423)	27862

Length

Max length	24
Median length	22
Mean length	18.284776
Min length	4

Characters and Unicode

Total characters	762530
Distinct characters	27
Distinct categories	5 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	14 ?
Unique (%)	< 0.1%

Sample

1st row	99 Yrs From 31/05/1993
2nd row	99 Yrs From 03/03/2014
3rd row	99 Yrs From 08/03/2018
4th row	99 Yrs From 29/11/2011
5th row	99 Yrs From 05/03/2004

Common Values

Value	Count	Frequency (%)
Freehold	11073	26.6%
99 Yrs From 31/05/2018	936	2.2%
99 Yrs From 05/12/2016	620	1.5%
99 Yrs From 31/07/2017	613	1.5%
99 Yrs From 25/08/2014	599	1.4%
99 Yrs From 18/08/2017	598	1.4%
99 Yrs From 11/10/2017	579	1.4%
99 Yrs From 28/12/2016	535	1.3%
99 Yrs From 30/05/2016	531	1.3%
99 Yrs From 03/03/2014	513	1.2%
Other values (418)	25106	60.2%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
from	30333	22.8%
yrs	30333	22.8%
99	29363	22.0%
freehold	11073	8.3%
999	988	0.7%
31/05/2018	936	0.7%
05/12/2016	620	0.5%
31/07/2017	613	0.5%
25/08/2014	599	0.4%
18/08/2017	598	0.4%
Other values (431)	27836	20.9%

Most occurring characters

Value	Count	Frequency (%)
	91623	12.0%
9	75429	9.9%
r	72034	9.4%
0	67676	8.9%
/	60666	8.0%
1	55089	7.2%
2	43797	5.7%
o	41701	5.5%
F	41406	5.4%
s	30923	4.1%
Other values (17)	182186	23.9%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	305188	40.0%
Lowercase Letter	232716	30.5%
Space Separator	91623	12.0%
Uppercase Letter	72333	9.5%
Other Punctuation	60670	8.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
9	75429	24.7%
0	67676	22.2%
1	55089	18.1%
2	43797	14.4%
8	13577	4.4%
5	12235	4.0%
7	11006	3.6%
3	10171	3.3%
6	9337	3.1%
4	6871	2.3%

Lowercase Letter

Value	Count	Frequency (%)
r	72034	31.0%
o	41701	17.9%
s	30923	13.3%
m	30333	13.0%
e	23031	9.9%
l	11368	4.9%
h	11368	4.9%
d	11368	4.9%
a	590	0.3%

Uppercase Letter

Value	Count	Frequency (%)
F	41406	57.2%
Y	30628	42.3%
L	295	0.4%
N	2	< 0.1%
A	2	< 0.1%

Other Punctuation

Value	Count	Frequency (%)
/	60666	> 99.9%
.	4	< 0.1%

Space Separator

Value	Count	Frequency (%)
	91623	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	457481	60.0%
Latin	305049	40.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
r	72034	23.6%
o	41701	13.7%
F	41406	13.6%
s	30923	10.1%
Y	30628	10.0%
m	30333	9.9%
e	23031	7.5%
l	11368	3.7%
h	11368	3.7%
d	11368	3.7%
Other values (4)	889	0.3%

Common

Value	Count	Frequency (%)
	91623	20.0%
9	75429	16.5%
0	67676	14.8%
/	60666	13.3%
1	55089	12.0%
2	43797	9.6%
8	13577	3.0%
5	12235	2.7%
7	11006	2.4%
3	10171	2.2%
Other values (3)	16212	3.5%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	762530	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	91623	12.0%
9	75429	9.9%
r	72034	9.4%
0	67676	8.9%
/	60666	8.0%
1	55089	7.2%
2	43797	5.7%
o	41701	5.5%
F	41406	5.4%
s	30923	4.1%
Other values (17)	182186	23.9%

completion_date
Real number (ℝ)

Distinct	56
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2013.8654

Minimum	1953
Maximum	2023
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	651.6 KiB

Quantile statistics

Minimum	1953
5-th percentile	1996
Q1	2008
median	2016
Q3	2023
95-th percentile	2023
Maximum	2023
Range	70
Interquartile range (IQR)	15

Descriptive statistics

Standard deviation	10.134357
Coefficient of variation (CV)	0.0050322909
Kurtosis	0.92124435
Mean	2013.8654
Median Absolute Deviation (MAD)	7
Skewness	-1.1134015
Sum	83984229
Variance	102.70518
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2023	16839	40.4%
2017	2558	6.1%
2015	1960	4.7%
2014	1936	4.6%
2016	1763	4.2%
2013	1396	3.3%
2011	1183	2.8%
2010	954	2.3%
2012	951	2.3%
2009	946	2.3%
Other values (46)	11217	26.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1953	2	< 0.1%
1954	2	< 0.1%
1955	1	< 0.1%
1966	1	< 0.1%
1967	2	< 0.1%
1968	1	< 0.1%
1971	2	< 0.1%
1972	11	< 0.1%
1973	1	< 0.1%
1974	7	< 0.1%

Value	Count	Frequency (%)
2023	16839	40.4%
2019	17	< 0.1%
2018	483	1.2%
2017	2558	6.1%
2016	1763	4.2%
2015	1960	4.7%
2014	1936	4.6%
2013	1396	3.3%
2012	951	2.3%
2011	1183	2.8%

sale_type
Categorical

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	651.6 KiB

Resale	22019
New Sale	19070
Sub Sale	614

Length

Max length	8
Median length	6
Mean length	6.9440088
Min length	6

Characters and Unicode

Total characters	289586
Distinct characters	11
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Resale
2nd row	Sub Sale
3rd row	New Sale
4th row	New Sale
5th row	Resale

Common Values

Value	Count	Frequency (%)
Resale	22019	52.8%
New Sale	19070	45.7%
Sub Sale	614	1.5%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
resale	22019	35.9%
sale	19684	32.1%
new	19070	31.1%
sub	614	1.0%

Most occurring characters

Value	Count	Frequency (%)
e	82792	28.6%
a	41703	14.4%
l	41703	14.4%
R	22019	7.6%
s	22019	7.6%
S	20298	7.0%
	19684	6.8%
N	19070	6.6%
w	19070	6.6%
u	614	0.2%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	208515	72.0%
Uppercase Letter	61387	21.2%
Space Separator	19684	6.8%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	82792	39.7%
a	41703	20.0%
l	41703	20.0%
s	22019	10.6%
w	19070	9.1%
u	614	0.3%
b	614	0.3%

Uppercase Letter

Value	Count	Frequency (%)
R	22019	35.9%
S	20298	33.1%
N	19070	31.1%

Space Separator

Value	Count	Frequency (%)
	19684	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	269902	93.2%
Common	19684	6.8%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	82792	30.7%
a	41703	15.5%
l	41703	15.5%
R	22019	8.2%
s	22019	8.2%
S	20298	7.5%
N	19070	7.1%
w	19070	7.1%
u	614	0.2%
b	614	0.2%

Common

Value	Count	Frequency (%)
	19684	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	289586	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	82792	28.6%
a	41703	14.4%
l	41703	14.4%
R	22019	7.6%
s	22019	7.6%
S	20298	7.0%
	19684	6.8%
N	19070	6.6%
w	19070	6.6%
u	614	0.2%

purchaser_address
Categorical

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	651.6 KiB

Private	19700
HDB	15796
N.A	6207

Length

Max length	7
Median length	3
Mean length	4.8895523
Min length	3

Characters and Unicode

Total characters	203909
Distinct characters	13
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Private
2nd row	Private
3rd row	N.A
4th row	N.A
5th row	Private

Common Values

Value	Count	Frequency (%)
Private	19700	47.2%
HDB	15796	37.9%
N.A	6207	14.9%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
private	19700	47.2%
hdb	15796	37.9%
n.a	6207	14.9%

Most occurring characters

Value	Count	Frequency (%)
P	19700	9.7%
r	19700	9.7%
i	19700	9.7%
v	19700	9.7%
a	19700	9.7%
t	19700	9.7%
e	19700	9.7%
H	15796	7.7%
D	15796	7.7%
B	15796	7.7%
Other values (3)	18621	9.1%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	118200	58.0%
Uppercase Letter	79502	39.0%
Other Punctuation	6207	3.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
P	19700	24.8%
H	15796	19.9%
D	15796	19.9%
B	15796	19.9%
N	6207	7.8%
A	6207	7.8%

Lowercase Letter

Value	Count	Frequency (%)
r	19700	16.7%
i	19700	16.7%
v	19700	16.7%
a	19700	16.7%
t	19700	16.7%
e	19700	16.7%

Other Punctuation

Value	Count	Frequency (%)
.	6207	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	197702	97.0%
Common	6207	3.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
P	19700	10.0%
r	19700	10.0%
i	19700	10.0%
v	19700	10.0%
a	19700	10.0%
t	19700	10.0%
e	19700	10.0%
H	15796	8.0%
D	15796	8.0%
B	15796	8.0%
Other values (2)	12414	6.3%

Common

Value	Count	Frequency (%)
.	6207	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	203909	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
P	19700	9.7%
r	19700	9.7%
i	19700	9.7%
v	19700	9.7%
a	19700	9.7%
t	19700	9.7%
e	19700	9.7%
H	15796	7.7%
D	15796	7.7%
B	15796	7.7%
Other values (3)	18621	9.1%

postal_district
Real number (ℝ)

Distinct	27
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	14.982231

Minimum	1
Maximum	28
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	651.6 KiB

Quantile statistics

Minimum	1
5-th percentile	3
Q1	10
median	15
Q3	19
95-th percentile	27
Maximum	28
Range	27
Interquartile range (IQR)	9

Descriptive statistics

Standard deviation	7.0195228
Coefficient of variation (CV)	0.46852318
Kurtosis	-0.7830344
Mean	14.982231
Median Absolute Deviation (MAD)	5
Skewness	-0.15634662
Sum	624804
Variance	49.2737
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=27)

Value	Count	Frequency (%)
19	6155	14.8%
15	2817	6.8%
5	2795	6.7%
18	2759	6.6%
3	2696	6.5%
14	2524	6.1%
23	2485	6.0%
27	2281	5.5%
9	2258	5.4%
10	2130	5.1%
Other values (17)	12803	30.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	426	1.0%
2	459	1.1%
3	2696	6.5%
4	518	1.2%
5	2795	6.7%
6	2	< 0.1%
7	223	0.5%
8	505	1.2%
9	2258	5.4%
10	2130	5.1%

Value	Count	Frequency (%)
28	835	2.0%
27	2281	5.5%
26	251	0.6%
25	617	1.5%
23	2485	6.0%
22	728	1.7%
21	1157	2.8%
20	1107	2.7%
19	6155	14.8%
18	2759	6.6%

postal_sector
Real number (ℝ)

Distinct	69
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	42.709086

Minimum	1
Maximum	82
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	651.6 KiB

Quantile statistics

Minimum	1
5-th percentile	12
Q1	24
median	44
Q3	55
95-th percentile	76
Maximum	82
Range	81
Interquartile range (IQR)	31

Descriptive statistics

Standard deviation	20.530996
Coefficient of variation (CV)	0.4807173
Kurtosis	-0.95584916
Mean	42.709086
Median Absolute Deviation (MAD)	14
Skewness	-0.034008572
Sum	1781097
Variance	421.52181
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
53	2651	6.4%
54	2179	5.2%
12	1965	4.7%
52	1912	4.6%
76	1760	4.2%
14	1417	3.4%
23	1351	3.2%
35	1325	3.2%
43	1264	3.0%
15	988	2.4%
Other values (59)	24891	59.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	289	0.7%
5	13	< 0.1%
6	124	0.3%
7	321	0.8%
8	138	0.3%
9	390	0.9%
10	128	0.3%
11	681	1.6%
12	1965	4.7%
13	149	0.4%

Value	Count	Frequency (%)
82	531	1.3%
80	125	0.3%
79	710	1.7%
78	231	0.6%
77	20	< 0.1%
76	1760	4.2%
75	521	1.2%
73	617	1.5%
68	941	2.3%
67	490	1.2%

postal_code
Real number (ℝ)

Distinct	4647
Distinct (%)	11.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	434943.53

Minimum	18965
Maximum	828843
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	651.6 KiB

Quantile statistics

Minimum	18965
5-th percentile	126751
Q1	249566
median	449028
Q3	554341
95-th percentile	768131.9
Maximum	828843
Range	809878
Interquartile range (IQR)	304775

Descriptive statistics

Standard deviation	204878.16
Coefficient of variation (CV)	0.47104543
Kurtosis	-0.94666983
Mean	434943.53
Median Absolute Deviation (MAD)	141071
Skewness	-0.028736184
Sum	1.813845 × 10¹⁰
Variance	4.1975062 × 10¹⁰
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
126756	296	0.7%
148960	294	0.7%
148962	278	0.7%
158745	203	0.5%
149456	185	0.4%
237963	180	0.4%
357688	174	0.4%
149457	168	0.4%
533813	167	0.4%
126754	167	0.4%
Other values (4637)	39591	94.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
18965	3	< 0.1%
18978	107	0.3%
18979	82	0.2%
18980	25	0.1%
18985	32	0.1%
18987	40	0.1%
58416	2	< 0.1%
59108	11	< 0.1%
68803	37	0.1%
68814	42	0.1%

Value	Count	Frequency (%)
828843	2	< 0.1%
828842	6	< 0.1%
828841	1	< 0.1%
828840	1	< 0.1%
828833	6	< 0.1%
828832	10	< 0.1%
828831	7	< 0.1%
828830	5	< 0.1%
828823	7	< 0.1%
828822	10	< 0.1%

planning_region
Categorical

Distinct	5
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	651.6 KiB

Central Region	19402
North East Region	7420
East Region	6405
West Region	5526
North Region	2950

Length

Max length	17
Median length	14
Mean length	13.534014
Min length	11

Characters and Unicode

Total characters	564409
Distinct characters	17
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	East Region
2nd row	North East Region
3rd row	East Region
4th row	Central Region
5th row	Central Region

Common Values

Value	Count	Frequency (%)
Central Region	19402	46.5%
North East Region	7420	17.8%
East Region	6405	15.4%
West Region	5526	13.3%
North Region	2950	7.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
region	41703	45.9%
central	19402	21.4%
east	13825	15.2%
north	10370	11.4%
west	5526	6.1%

Most occurring characters

Value	Count	Frequency (%)
e	66631	11.8%
n	61105	10.8%
o	52073	9.2%
t	49123	8.7%
	49123	8.7%
R	41703	7.4%
i	41703	7.4%
g	41703	7.4%
a	33227	5.9%
r	29772	5.3%
Other values (7)	98246	17.4%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	424460	75.2%
Uppercase Letter	90826	16.1%
Space Separator	49123	8.7%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	66631	15.7%
n	61105	14.4%
o	52073	12.3%
t	49123	11.6%
i	41703	9.8%
g	41703	9.8%
a	33227	7.8%
r	29772	7.0%
l	19402	4.6%
s	19351	4.6%

Uppercase Letter

Value	Count	Frequency (%)
R	41703	45.9%
C	19402	21.4%
E	13825	15.2%
N	10370	11.4%
W	5526	6.1%

Space Separator

Value	Count	Frequency (%)
	49123	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	515286	91.3%
Common	49123	8.7%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	66631	12.9%
n	61105	11.9%
o	52073	10.1%
t	49123	9.5%
R	41703	8.1%
i	41703	8.1%
g	41703	8.1%
a	33227	6.4%
r	29772	5.8%
C	19402	3.8%
Other values (6)	78844	15.3%

Common

Value	Count	Frequency (%)
	49123	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	564409	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	66631	11.8%
n	61105	10.8%
o	52073	9.2%
t	49123	8.7%
	49123	8.7%
R	41703	7.4%
i	41703	7.4%
g	41703	7.4%
a	33227	5.9%
r	29772	5.3%
Other values (7)	98246	17.4%

planning_area
Categorical

Distinct	37
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	651.6 KiB

Hougang	3405
Bedok	2881
Geylang	2439
Queenstown	2322
Clementi	2018
Other values (32)	28638

Length

Max length	16
Median length	13
Mean length	8.577968
Min length	5

Characters and Unicode

Total characters	357727
Distinct characters	44
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Bedok
2nd row	Hougang
3rd row	Pasir Ris
4th row	Downtown Core
5th row	Bukit Merah

Common Values

Value	Count	Frequency (%)
Hougang	3405	8.2%
Bedok	2881	6.9%
Geylang	2439	5.8%
Queenstown	2322	5.6%
Clementi	2018	4.8%
Tampines	2003	4.8%
Toa Payoh	1855	4.4%
Sengkang	1847	4.4%
Bukit Merah	1716	4.1%
Bukit Timah	1702	4.1%
Other values (27)	19515	46.8%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
bukit	5235	9.2%
hougang	3405	6.0%
bedok	2881	5.0%
geylang	2439	4.3%
queenstown	2322	4.1%
clementi	2018	3.5%
tampines	2003	3.5%
toa	1855	3.3%
payoh	1855	3.3%
sengkang	1847	3.2%
Other values (39)	31197	54.7%

Most occurring characters

Value	Count	Frequency (%)
a	37304	10.4%
n	36745	10.3%
e	29969	8.4%
o	25957	7.3%
g	21503	6.0%
i	20468	5.7%
	15354	4.3%
u	14913	4.2%
t	13026	3.6%
l	11990	3.4%
Other values (34)	130498	36.5%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	285316	79.8%
Uppercase Letter	57057	15.9%
Space Separator	15354	4.3%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
a	37304	13.1%
n	36745	12.9%
e	29969	10.5%
o	25957	9.1%
g	21503	7.5%
i	20468	7.2%
u	14913	5.2%
t	13026	4.6%
l	11990	4.2%
s	11306	4.0%
Other values (12)	62135	21.8%

Uppercase Letter

Value	Count	Frequency (%)
B	10274	18.0%
T	6567	11.5%
P	5442	9.5%
C	4768	8.4%
S	4305	7.5%
R	3461	6.1%
H	3405	6.0%
M	3176	5.6%
K	2804	4.9%
G	2439	4.3%
Other values (11)	10416	18.3%

Space Separator

Value	Count	Frequency (%)
	15354	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	342373	95.7%
Common	15354	4.3%

Most frequent character per script

Latin

Value	Count	Frequency (%)
a	37304	10.9%
n	36745	10.7%
e	29969	8.8%
o	25957	7.6%
g	21503	6.3%
i	20468	6.0%
u	14913	4.4%
t	13026	3.8%
l	11990	3.5%
s	11306	3.3%
Other values (33)	119192	34.8%

Common

Value	Count	Frequency (%)
	15354	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	357727	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
a	37304	10.4%
n	36745	10.3%
e	29969	8.4%
o	25957	7.3%
g	21503	6.0%
i	20468	5.7%
	15354	4.3%
u	14913	4.2%
t	13026	3.6%
l	11990	3.4%
Other values (34)	130498	36.5%

date_id
Real number (ℝ)

Distinct	698
Distinct (%)	1.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	306.83512

Minimum	0
Maximum	697
Zeros	67
Zeros (%)	0.2%
Negative	0
Negative (%)	0.0%
Memory size	651.6 KiB

Quantile statistics

Minimum	0
5-th percentile	28
Q1	136
median	310
Q3	437
95-th percentile	654
Maximum	697
Range	697
Interquartile range (IQR)	301

Descriptive statistics

Standard deviation	191.93928
Coefficient of variation (CV)	0.62554533
Kurtosis	-0.97132853
Mean	306.83512
Median Absolute Deviation (MAD)	153
Skewness	0.24317778
Sum	12795945
Variance	36840.686
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
429	990	2.4%
82	590	1.4%
347	465	1.1%
368	375	0.9%
508	308	0.7%
96	305	0.7%
326	304	0.7%
689	249	0.6%
194	235	0.6%
340	228	0.5%
Other values (688)	37654	90.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	67	0.2%
1	81	0.2%
2	96	0.2%
3	71	0.2%
4	105	0.3%
5	38	0.1%
6	47	0.1%
7	123	0.3%
8	82	0.2%
9	62	0.1%

Value	Count	Frequency (%)
697	41	0.1%
696	41	0.1%
695	39	0.1%
694	55	0.1%
693	49	0.1%
692	48	0.1%
691	57	0.1%
690	38	0.1%
689	249	0.6%
688	74	0.2%

is_leasehold
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	651.6 KiB

1	29366
0	12337

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	41703
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	1
2nd row	1
3rd row	1
4th row	1
5th row	1

Common Values

Value	Count	Frequency (%)
1	29366	70.4%
0	12337	29.6%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
1	29366	70.4%
0	12337	29.6%

Most occurring characters

Value	Count	Frequency (%)
1	29366	70.4%
0	12337	29.6%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	41703	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
1	29366	70.4%
0	12337	29.6%

Most occurring scripts

Value	Count	Frequency (%)
Common	41703	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
1	29366	70.4%
0	12337	29.6%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	41703	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
1	29366	70.4%
0	12337	29.6%

lat
Real number (ℝ)

Distinct	4540
Distinct (%)	10.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.3396511

Minimum	1.2393366
Maximum	1.4564363
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	651.6 KiB

Quantile statistics

Minimum	1.2393366
5-th percentile	1.2845173
Q1	1.3078028
median	1.333824
Q3	1.3692643
95-th percentile	1.4239064
Maximum	1.4564363
Range	0.21709963
Interquartile range (IQR)	0.06146149

Descriptive statistics

Standard deviation	0.041217093
Coefficient of variation (CV)	0.030767036
Kurtosis	-0.11519856
Mean	1.3396511
Median Absolute Deviation (MAD)	0.028669678
Skewness	0.63271513
Sum	55867.468
Variance	0.0016988487
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1.31968768	296	0.7%
1.292054817	294	0.7%
1.291149506	278	0.7%
1.290030671	203	0.5%
1.294746118	185	0.4%
1.293037367	180	0.4%
1.338538839	174	0.4%
1.294336667	168	0.4%
1.320614301	167	0.4%
1.370170753	167	0.4%
Other values (4530)	39591	94.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1.239336627	4	< 0.1%
1.239415475	1	< 0.1%
1.239948547	1	< 0.1%
1.242440985	7	< 0.1%
1.242963992	1	< 0.1%
1.242974246	2	< 0.1%
1.243234247	5	< 0.1%
1.243744865	7	< 0.1%
1.244007259	4	< 0.1%
1.244201733	7	< 0.1%

Value	Count	Frequency (%)
1.456436254	11	< 0.1%
1.456211379	10	< 0.1%
1.456182921	18	< 0.1%
1.456008947	12	< 0.1%
1.448200366	4	< 0.1%
1.447039421	35	0.1%
1.446856479	14	< 0.1%
1.446681447	7	< 0.1%
1.446633687	30	0.1%
1.446515198	11	< 0.1%

lon
Real number (ℝ)

Distinct	4520
Distinct (%)	10.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	103.85135

Minimum	103.69561
Maximum	103.97119
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	651.6 KiB

Quantile statistics

Minimum	103.69561
5-th percentile	103.75158
Q1	103.81206
median	103.85069
Q3	103.89602
95-th percentile	103.94561
Maximum	103.97119
Range	0.2755851
Interquartile range (IQR)	0.08396415

Descriptive statistics

Standard deviation	0.058796372
Coefficient of variation (CV)	0.00056615899
Kurtosis	-0.56852466
Mean	103.85135
Median Absolute Deviation (MAD)	0.0420593
Skewness	-0.20412775
Sum	4330912.7
Variance	0.0034570134
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
103.7526994	296	0.7%
103.8055464	294	0.7%
103.8045736	278	0.7%
103.8171853	203	0.5%
103.8068303	185	0.4%
103.8377728	180	0.4%
103.87008	174	0.4%
103.8070201	168	0.4%
103.8999986	167	0.4%
103.7532909	167	0.4%
Other values (4510)	39591	94.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
103.6956085	2	< 0.1%
103.6958568	2	< 0.1%
103.6961287	3	< 0.1%
103.6961471	1	< 0.1%
103.6962149	11	< 0.1%
103.6963648	10	< 0.1%
103.6963988	3	< 0.1%
103.6965264	2	< 0.1%
103.6965346	8	< 0.1%
103.696551	19	< 0.1%

Value	Count	Frequency (%)
103.9711936	4	< 0.1%
103.9710988	1	< 0.1%
103.9710089	4	< 0.1%
103.9706894	3	< 0.1%
103.9706773	1	< 0.1%
103.9705715	3	< 0.1%
103.9703292	2	< 0.1%
103.9700192	5	< 0.1%
103.9698251	2	< 0.1%
103.9695964	1	< 0.1%

Auto

Heatmap
Table

	area_sqm	total_price	price_psm	price_psf	completion_date	postal_district	postal_sector	postal_code	date_id	lat	lon	area_type	property_type	sale_type	purchaser_address	planning_region	planning_area	is_leasehold
area_sqm	1.000	0.657	-0.315	-0.315	-0.476	0.020	0.018	0.023	-0.107	-0.023	-0.073	0.026	0.154	0.281	0.196	0.085	0.130	0.229
total_price	0.657	1.000	0.434	0.434	-0.174	-0.448	-0.441	-0.438	0.046	-0.516	-0.150	0.000	0.059	0.076	0.101	0.090	0.158	0.169
price_psm	-0.315	0.434	1.000	1.000	0.319	-0.613	-0.600	-0.602	0.190	-0.653	-0.124	0.000	0.438	0.183	0.183	0.355	0.363	0.265
price_psf	-0.315	0.434	1.000	1.000	0.319	-0.613	-0.600	-0.602	0.190	-0.653	-0.124	0.000	0.438	0.183	0.183	0.355	0.363	0.265
completion_date	-0.476	-0.174	0.319	0.319	1.000	0.026	0.027	0.017	0.064	0.143	0.004	0.000	0.220	0.677	0.329	0.137	0.234	0.431
postal_district	0.020	-0.448	-0.613	-0.613	0.026	1.000	0.987	0.986	-0.054	0.880	0.123	0.000	0.368	0.269	0.245	0.733	0.856	0.530
postal_sector	0.018	-0.441	-0.600	-0.600	0.027	0.987	1.000	1.000	-0.051	0.877	0.148	0.003	0.363	0.268	0.253	0.680	0.874	0.521
postal_code	0.023	-0.438	-0.602	-0.602	0.017	0.986	1.000	1.000	-0.055	0.875	0.148	0.002	0.363	0.266	0.252	0.679	0.873	0.519
date_id	-0.107	0.046	0.190	0.190	0.064	-0.054	-0.051	-0.055	1.000	-0.021	0.099	0.000	0.186	0.109	0.232	0.121	0.176	0.098
lat	-0.023	-0.516	-0.653	-0.653	0.143	0.880	0.877	0.875	-0.021	1.000	0.162	0.000	0.466	0.174	0.203	0.657	0.815	0.383
lon	-0.073	-0.150	-0.124	-0.124	0.004	0.123	0.148	0.148	0.099	0.162	1.000	0.000	0.287	0.144	0.136	0.735	0.785	0.237
area_type	0.026	0.000	0.000	0.000	0.000	0.000	0.003	0.002	0.000	0.000	0.000	1.000	0.000	0.000	0.000	0.000	0.000	0.000
property_type	0.154	0.059	0.438	0.438	0.220	0.368	0.363	0.363	0.186	0.466	0.287	0.000	1.000	0.217	0.173	0.392	0.580	0.262
sale_type	0.281	0.076	0.183	0.183	0.677	0.269	0.268	0.266	0.109	0.174	0.144	0.000	0.217	1.000	0.344	0.156	0.393	0.421
purchaser_address	0.196	0.101	0.183	0.183	0.329	0.245	0.253	0.252	0.232	0.203	0.136	0.000	0.173	0.344	1.000	0.192	0.297	0.266
planning_region	0.085	0.090	0.355	0.355	0.137	0.733	0.680	0.679	0.121	0.657	0.735	0.000	0.392	0.156	0.192	1.000	1.000	0.358
planning_area	0.130	0.158	0.363	0.363	0.234	0.856	0.874	0.873	0.176	0.815	0.785	0.000	0.580	0.393	0.297	1.000	1.000	0.621
is_leasehold	0.229	0.169	0.265	0.265	0.431	0.530	0.521	0.519	0.098	0.383	0.237	0.000	0.262	0.421	0.266	0.358	0.621	1.000

Count
Matrix

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

First rows
Last rows

	project_name	address	num_units	area_sqm	area_type	total_price	nett_price	price_psm	price_psf	sale_date	property_type	tenure	completion_date	sale_type	purchaser_address	postal_district	postal_sector	postal_code	planning_region	planning_area	date_id	is_leasehold	lat	lon
0	THE BAYSHORE	22 Bayshore Road #03-02	1	88	Strata	888000	-	10091	937	2019-02-28	Condominium	99 Yrs From 31/05/1993	1996	Resale	Private	16	46	469970	East Region	Bedok	666	1	1.312420	103.938628
1	KINGSFORD WATERBAY	66 Upper Serangoon View #16-12	1	102	Strata	1280000	-	12549	1166	2019-02-28	Apartment	99 Yrs From 03/03/2014	2018	Sub Sale	Private	19	53	533885	North East Region	Hougang	666	1	1.373526	103.902708
2	THE JOVELL	13 Flora Drive #02-11	1	42	Strata	615000	-	14643	1360	2019-02-28	Condominium	99 Yrs From 08/03/2018	2023	New Sale	N.A	17	50	506853	East Region	Pasir Ris	666	1	1.358005	103.965725
3	V ON SHENTON	5A Shenton Way #44-12	1	112	Strata	2855680	2847680	25426	2362	2019-02-28	Apartment	99 Yrs From 29/11/2011	2017	New Sale	N.A	1	6	68814	Central Region	Downtown Core	666	1	1.277083	103.849181
4	THE BEACON	130 Cantonment Road #10-04	1	103	Strata	1570000	-	15243	1416	2019-02-28	Apartment	99 Yrs From 05/03/2004	2008	Resale	Private	2	8	89775	Central Region	Bukit Merah	666	1	1.275875	103.840481
5	WATERBANK AT DAKOTA	78 Dakota Crescent #09-16	1	58	Strata	1080000	-	18621	1730	2019-02-28	Condominium	99 Yrs From 07/12/2009	2013	Resale	Private	14	39	399945	Central Region	Geylang	666	1	1.306554	103.888847
6	MARGARET VILLE	20 Margaret Drive #15-03	1	85	Strata	1560650	-	18361	1706	2019-02-28	Apartment	99 Yrs From 13/03/2017	2023	New Sale	N.A	3	14	149312	Central Region	Queenstown	666	1	1.299517	103.802807
7	PARK COLONIAL	4 Woodleigh Lane #10-12	1	63	Strata	1359000	-	21571	2004	2019-02-28	Condominium	99 Yrs From 11/10/2017	2023	New Sale	N.A	13	35	357686	Central Region	Toa Payoh	666	1	1.338682	103.869252
8	BREEZE BY THE EAST	316 Upper East Coast Road #04-03	1	116	Strata	1530000	-	13190	1225	2019-02-28	Condominium	Freehold	2011	Resale	Private	16	46	465520	East Region	Bedok	666	0	1.314138	103.937742
9	THE TRE VER	64 Potong Pasir Avenue 1 #14-24	1	65	Strata	1127112	-	17340	1611	2019-02-28	Condominium	99 Yrs From 27/03/2018	2023	New Sale	N.A	13	35	358393	Central Region	Toa Payoh	666	1	1.336988	103.864798

	project_name	address	num_units	area_sqm	area_type	total_price	nett_price	price_psm	price_psf	sale_date	property_type	tenure	completion_date	sale_type	purchaser_address	postal_district	postal_sector	postal_code	planning_region	planning_area	date_id	is_leasehold	lat	lon
41728	QUEENS	12 Stirling Road #07-12	1	110	Strata	1468000	-	13345	1240	2018-08-01	Condominium	99 Yrs From 16/02/1998	2002	Resale	HDB	3	14	148955	Central Region	Queenstown	456	1	1.293048	103.806248
41729	EAST MEADOWS	32 Tanah Merah Kechil Road #03-23	1	111	Strata	1090000	-	9820	912	2018-08-01	Condominium	99 Yrs From 02/03/1998	2002	Resale	HDB	16	46	465559	East Region	Bedok	456	1	1.329294	103.944215
41730	SIMSVILLE	10 Geylang East Avenue 2 #03-08	1	91	Strata	960000	-	10549	980	2018-08-01	Condominium	99 Yrs From 01/12/1994	1998	Resale	Private	14	38	389758	Central Region	Geylang	456	1	1.316866	103.888865
41731	THE COAST AT SENTOSA COVE	276 Ocean Drive #03-26	1	244	Strata	4688000	-	19213	1785	2018-08-01	Condominium	99 Yrs From 11/04/2006	2009	Resale	Private	4	9	98449	Central Region	Southern Islands	456	1	1.246787	103.844402
41732	CASTLE GREEN	485 Yio Chu Kang Road #04-16	1	88	Strata	810000	-	9205	855	2018-08-01	Condominium	99 Yrs From 01/12/1993	1997	Resale	Private	26	78	787058	North East Region	Ang Mo Kio	456	1	1.385429	103.840723
41733	PRIVE	37 Punggol Field #03-36	1	77	Strata	828000	-	10753	999	2018-08-01	Executive Condominium	99 Yrs From 14/09/2010	2013	Resale	HDB	19	82	828809	North East Region	Punggol	456	1	1.400676	103.904700
41734	PARK GREEN	12 Rivervale Link #17-21	1	193	Strata	1470000	-	7617	708	2018-08-01	Executive Condominium	99 Yrs From 17/08/2001	2004	Resale	HDB	19	54	545045	North East Region	Sengkang	456	1	1.381216	103.900166
41735	PRIVE	37 Punggol Field #09-35	1	77	Strata	770000	-	10000	929	2018-08-01	Executive Condominium	99 Yrs From 14/09/2010	2013	Resale	Private	19	82	828809	North East Region	Punggol	456	1	1.400676	103.904700
41736	EIGHT COURTYARDS	12 Canberra Drive #11-24	1	106	Strata	1100000	-	10377	964	2018-08-01	Condominium	99 Yrs From 20/09/2010	2014	Resale	Private	27	76	768094	North Region	Yishun	456	1	1.438963	103.831365
41737	BARTLEY RESIDENCES	3A Lorong How Sun #09-19	1	99	Strata	1420000	-	14343	1333	2018-08-01	Apartment	99 Yrs From 29/06/2011	2015	Resale	Private	19	53	536561	North East Region	Serangoon	456	1	1.342722	103.881873

Overview

Variables

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Decimal Number

Other Punctuation

Space Separator

Dash Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Decimal Number

Other Punctuation

Space Separator

Dash Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Most occurring scripts

Most frequent character per script

Latin

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Dash Punctuation

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)